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