UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3J7xftKVN4BwwoABY9Yw4T0hfzTtuBlQvlNb/4kYWT4='
WHERE
key_id = '84e7ede7153a5229335898509cf2262c4e762e8278edd203c669b72256e973be'
AND (
token = '3J7xftKVN4BwwoABY9Yw4T0hfzTtuBlQvlNb/4kYWT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)