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