UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D15GRhOQYLqmqxilwa2DjEOOZA8X0Ff08mz+6aMlMjo='
WHERE
key_id = '4f1728697126f0e36486f0a114e508f269f73f12ff58725c6360be805d1c58ed'
AND (
token = 'D15GRhOQYLqmqxilwa2DjEOOZA8X0Ff08mz+6aMlMjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)