UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yPIfVZGjzxDUH1E16fZBOnwA7gz0bqq2nmVgmvIdNxU='
WHERE
key_id = 'b41a0de1424335fe27a61f3dd12ea56b615ea2fe45108ded2ff68f2565ae28be'
AND (
token = 'yPIfVZGjzxDUH1E16fZBOnwA7gz0bqq2nmVgmvIdNxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)