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