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