UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TK9E4smvc7molcmT/RBhdtIS1d9Hia3dmiaMM/tVKes='
WHERE
key_id = 'bb593024dc15f63e8379ea456f499b4f7746205e4701ca441a6a3341d6443960'
AND (
token = 'TK9E4smvc7molcmT/RBhdtIS1d9Hia3dmiaMM/tVKes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)