UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XfrWydyqRNiDnfEhH28IqZR76jTO/OhlhTsaJRTcn4='
WHERE
key_id = '479f75cb1aabd33dd3eed385e2b4fdba77432321a60c77b12bbd36f46127a1dc'
AND (
token = '6XfrWydyqRNiDnfEhH28IqZR76jTO/OhlhTsaJRTcn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)