UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8TSVArQpLxT9Iv0YRmDrwVKEv5vzFPk2qAyk9pIMZA='
WHERE
key_id = '5696511f5cdea3615e7596f4e83bded17e66a9dfc828c98efb0b98e71945ced5'
AND (
token = 'C8TSVArQpLxT9Iv0YRmDrwVKEv5vzFPk2qAyk9pIMZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)