UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xo4P/nwE59XJTgbD00iHbCFtWq85bb70KlH6NsPYezo='
WHERE
key_id = 'ae313ac28d4e39ceed0e75d03203e1a8975543601371896c217d162ccf8a00ff'
AND (
token = 'xo4P/nwE59XJTgbD00iHbCFtWq85bb70KlH6NsPYezo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)