UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sJG1O78BbsLKIZPeIddCPIfkx3h3koNN+sS/Fie4Ik0='
WHERE
key_id = '47e74ea880425b5ae64e3397c6d158d05f5774f58ce1e54bae2598914f28e0dd'
AND (
token = 'sJG1O78BbsLKIZPeIddCPIfkx3h3koNN+sS/Fie4Ik0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)