UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdnrtrWrFAjfv258Y2gitoVB8TAd1cvkKZqHi2wmbtY='
WHERE
key_id = '455df4f572a59c9c3a60487f5f59b4a527b7181fc8ed0d28d08467164026158c'
AND (
token = 'zdnrtrWrFAjfv258Y2gitoVB8TAd1cvkKZqHi2wmbtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)