UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0jUC9L8oXyFafAqMgssQCotJ/VmOlUoZaxtJOhtaOV4='
WHERE
key_id = '7c88fe10eaf7f0b1f47e822d6163671ed014b017226796b4701bc7437d752d4f'
AND (
token = '0jUC9L8oXyFafAqMgssQCotJ/VmOlUoZaxtJOhtaOV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)