UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7kSGRa5lyK+X48cHSvUIawG5QT1ytA4MGdKTlwv23lo='
WHERE
key_id = 'df874572ef64e9e574dbd0e25375d5a33997f27a64b470ddc807fa34314dabb3'
AND (
token = '7kSGRa5lyK+X48cHSvUIawG5QT1ytA4MGdKTlwv23lo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)