UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PVf4e3glPO7yT7cr4sPsVgtF+fgGCDntTI/V3RkFCdU='
WHERE
key_id = 'c82f8672366e5ce6edfcd88129c1df0a89e572d8d557091d304af05a58e5cc6b'
AND (
token = 'PVf4e3glPO7yT7cr4sPsVgtF+fgGCDntTI/V3RkFCdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)