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