UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rkgM5SFrAV4igBpR3WGiYRzbt0zuTdJYr1wfV85mHjo='
WHERE
key_id = '64a9ab4b15943f80aa114c7ca11f12e82862c490542f2be1cfd67f15d1dee58b'
AND (
token = 'rkgM5SFrAV4igBpR3WGiYRzbt0zuTdJYr1wfV85mHjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)