UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7Z8fzelCM49YPhhimMS6sY/ugfqe6wi5oSMnmgj3Ic='
WHERE
key_id = 'e44fd7f6b664d2a3b65eb18afd55fe5aee9f03b9ece382df620df9a1180b12b7'
AND (
token = 'a7Z8fzelCM49YPhhimMS6sY/ugfqe6wi5oSMnmgj3Ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)