UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHGt+yGLIOAlAEhhsRksMaVWxWXbY+3570l8CICNCWk='
WHERE
key_id = 'a249d33cc2201487cd776b12d4bf44c4d3ef7d59f2de4e2fdac7978ce92cf731'
AND (
token = 'xHGt+yGLIOAlAEhhsRksMaVWxWXbY+3570l8CICNCWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)