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