UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g8zvdTuqMfYRERT3svYOQlfoSi6Y+PxK7IF4wulv4l0='
WHERE
key_id = '2a578d772463b943676e58be01609475f9b5d1ea6629c8f87b54f0b8e350c780'
AND (
token = 'g8zvdTuqMfYRERT3svYOQlfoSi6Y+PxK7IF4wulv4l0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)