UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MKf4MtvVRO8SmX78ULa0ymb701hWhRY64gQby3vRUm4='
WHERE
key_id = 'bd5b43f1abec837bc50bb08b8724a07660b83bb0b74ef98057477c1f92e2054a'
AND (
token = 'MKf4MtvVRO8SmX78ULa0ymb701hWhRY64gQby3vRUm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)