UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2DomGFUdGwwXZT96w6+fymlQ6eQ8cTjhVH3/OZvO38g='
WHERE
key_id = '31062772e74f973ea0ad45f09df7c0871e8b0b3a9bbae16857f3ef84790febca'
AND (
token = '2DomGFUdGwwXZT96w6+fymlQ6eQ8cTjhVH3/OZvO38g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)