UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOsYFp4F56NW2/RnmzWAs2dOGdDtcO2yvXSxQ5Xq3J0='
WHERE
key_id = 'be04c93078fd9fd108dc0234436b6c060285eb9135aa8411b22fee29e077cda4'
AND (
token = 'lOsYFp4F56NW2/RnmzWAs2dOGdDtcO2yvXSxQ5Xq3J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)