UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B7VCirxcN5AiTP8+uUljP244DoUUE5HApkmN6mANrRU='
WHERE
key_id = '19f0d4ac710cb3714d9b40e68c0111218990fe5a1db0757231724ae2604ed818'
AND (
token = 'B7VCirxcN5AiTP8+uUljP244DoUUE5HApkmN6mANrRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)