UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y4CfRcdckEfFLyHDvj84xyGLB9bxT1jTQ5jB7vY3zgI='
WHERE
key_id = 'ba34b53598b8cb42c197cfc2766bd910364035f6592d711ac31016e16d7e89be'
AND (
token = 'y4CfRcdckEfFLyHDvj84xyGLB9bxT1jTQ5jB7vY3zgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)