UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTOfDEboOoxLVTelg0llmdPMlpLsv7fXtpPIeDHn6O0='
WHERE
key_id = '1a4309439e21a5673447d7463cbc9f8a456c183c2c796e0784a53d9f01c39590'
AND (
token = 'BTOfDEboOoxLVTelg0llmdPMlpLsv7fXtpPIeDHn6O0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)