UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjfGQH0PkQTnNfKaxsPXBhk/mK/pzdcEn6j2iS+HDqg='
WHERE
key_id = 'fe491cce40f999009abadce6e470aca973ef314b84bd8eeceb4f308455814a40'
AND (
token = 'pjfGQH0PkQTnNfKaxsPXBhk/mK/pzdcEn6j2iS+HDqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)