UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smJrcExwwSVr/qX2CM4ftddiviube9PJrNzzGq9npYs='
WHERE
key_id = '1814e9b79522822e82839fc8fc4b5e5686bbdeac8b9b65dbea2cb266b450f801'
AND (
token = 'smJrcExwwSVr/qX2CM4ftddiviube9PJrNzzGq9npYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)