UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0TmeGqptGuF068bC3c+m1W+35oSOorChqWulUskwwA='
WHERE
key_id = '303128581755e842ad182fda00e040c1dc9cf2f8c54f4f48318f1eed7390dd02'
AND (
token = 'B0TmeGqptGuF068bC3c+m1W+35oSOorChqWulUskwwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)