UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQZs+cBchXjrHSiY031ej/ouWIfZ3u2IS+Omsd0PMOE='
WHERE
key_id = '14497976b99079720caa8fedb3b3d08855c35eed1578b194bc56abfc998a9d71'
AND (
token = 'XQZs+cBchXjrHSiY031ej/ouWIfZ3u2IS+Omsd0PMOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)