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