UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LG1+xVlzUEXHc7ypfnDNMN1rClkhTbhRzczCCDb1Kkg='
WHERE
key_id = '6aaf89398c4a29ac552a490a78ac6a8d7f7a5d586829dc8e772b374b24f9e6a0'
AND (
token = 'LG1+xVlzUEXHc7ypfnDNMN1rClkhTbhRzczCCDb1Kkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)