UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mEYl1TfTJ3OMcWiOkQ8diKE2MApH5+qNW6ATWj1rF0='
WHERE
key_id = '7269370d914070d3a5b996fa696a4889f6404f735583a77510b393bcd5af06ec'
AND (
token = '8mEYl1TfTJ3OMcWiOkQ8diKE2MApH5+qNW6ATWj1rF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)